package com.tsd.jxc.stock.dao;

import com.tsd.common.vo.BatchDeleteLogicVo;
import com.tsd.core.vo.PageBean;
import com.tsd.jxc.stock.entity.JxcStockOutbill;
import com.tsd.jxc.stock.entity.JxcStockOutbillExt;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * 描述：JxcStockOutbillMapper
 *
 * @author Hillpool
 * @date 2022/07/29 15:06:41
 */
public interface JxcStockOutbillMapper {

    JxcStockOutbill selectByPrimaryKey(Long id);

    JxcStockOutbillExt selectBySid(String sid);

    int deleteByPrimaryKey(Long id);

    int insert(JxcStockOutbill record);

    int insertSelective(JxcStockOutbill record);

    int insertList(@Param("list") List<JxcStockOutbillExt> list);

    int updateByPrimaryKey(JxcStockOutbill record);

    int updateByPrimaryKeySelective(JxcStockOutbill record);

    int updateList(@Param("list") List<JxcStockOutbillExt> list);

    List<JxcStockOutbillExt> selectByEntity(JxcStockOutbillExt record);

    List<JxcStockOutbillExt> selectByPage(@Param("params") Map<String, Object> params, @Param("page") PageBean page);

    List<JxcStockOutbillExt> selectCount1Page(@Param("params") Map<String, Object> params, @Param("page") PageBean page);

    List<JxcStockOutbillExt> selectByParams(@Param("params") Map<String, Object> params);

    JxcStockOutbillExt selectDuplicatedCode(JxcStockOutbillExt record);

    int deleteLogicBySidList(BatchDeleteLogicVo logicVo);

    int updateOutQty(@Param("bill_sid") String bill_sid);

    List<JxcStockOutbillExt> selectStockOutbillsIncludeDetailByPage(@Param("params") Map<String, Object> params, @Param("page") PageBean page);

    int countValid(@Param("yyyy") Integer yyyy, @Param("mm") Integer mm);

    List<JxcStockOutbillExt> selectBySrcSid(@Param("list") List<String> list, @Param("dr") int dr);

}
